﻿
CREATE PROCEDURE [dbo].[proc_Order_PaymentRecord_Update]
(
	@CId int,
    @OId uniqueidentifier,
	@id INT,
	@shjbh VARCHAR(50),
	@prices DECIMAL(18,2),
	@paymentTypeID INT,
	@paymentType NVARCHAR(50),
	@bankId INT,
	@bank NVARCHAR(50)
)
AS
BEGIN
UPDATE [Order_PaymentRecord]
	SET [Prices] = @prices
      ,[PaymentTypeId] = @paymentTypeID
      ,[PaymentType] = @paymentType
      ,[BankId] = @bankId
      ,[Bank] = @bank
      ,[shjbh] = @shjbh
	WHERE [id]=@id
Update [Order_Change] Set flag=1 Where OId=@OId And Id=@CId And flag=0
END